<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_users`;");
E_C("CREATE TABLE `ecs_users` (
  `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `aite_id` text NOT NULL,
  `email` varchar(60) NOT NULL DEFAULT '',
  `user_name` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `question` varchar(255) NOT NULL DEFAULT '',
  `answer` varchar(255) NOT NULL DEFAULT '',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `birthday` date NOT NULL DEFAULT '0000-00-00',
  `user_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `frozen_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pay_points` int(10) unsigned NOT NULL DEFAULT '0',
  `rank_points` int(10) unsigned NOT NULL DEFAULT '0',
  `address_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0',
  `last_login` int(11) unsigned NOT NULL DEFAULT '0',
  `last_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_ip` varchar(15) NOT NULL DEFAULT '',
  `visit_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `user_rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_special` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ec_salt` varchar(10) DEFAULT NULL,
  `salt` varchar(10) NOT NULL DEFAULT '0',
  `parent_id` mediumint(9) NOT NULL DEFAULT '0',
  `flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `alias` varchar(60) NOT NULL,
  `msn` varchar(60) NOT NULL,
  `qq` varchar(20) NOT NULL,
  `office_phone` varchar(20) NOT NULL,
  `home_phone` varchar(20) NOT NULL,
  `mobile_phone` varchar(20) NOT NULL,
  `is_validated` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `credit_line` decimal(10,2) unsigned NOT NULL,
  `passwd_question` varchar(50) DEFAULT NULL,
  `passwd_answer` varchar(255) DEFAULT NULL,
  `mediaUID` varchar(50) NOT NULL,
  `mediaID` int(4) NOT NULL,
  `froms` char(10) NOT NULL DEFAULT 'pc' COMMENT 'pc:电脑,mobile:手机,app:应用',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `email` (`email`),
  KEY `parent_id` (`parent_id`),
  KEY `flag` (`flag`),
  KEY `mediaUID` (`mediaUID`,`mediaID`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_users` values('1','','Yasfd@sdf.com','68ecshop','0ac507d810731e720a14cc19426f0f2c','','','0','1954-01-01','85355.00','0.00','15375','14975','3','1358477870','1411700856','0000-00-00 00:00:00','192.168.0.165','9630','0','0','4651','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('2','','aa943878b4@example.com','想飞的魚','1834ed2bfa3811afee67ab831eddd435','','','0','1953-01-01','0.00','0.00','0','0','0','0','1358833262','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','24986273','13','pc');");
E_D("replace into `ecs_users` values('3','','asdfsadf@sdf.com','asdfasd','669599770acb61a49785fedc0d22c7ae','','','0','1954-01-01','0.00','0.00','777','777','6','1358925669','1406682002','0000-00-00 00:00:00','127.0.0.1','2','0','0','7074','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('4','','asdf@asdf.com','68ec','f6b09fe6c3c0014fa3f7cac775579e9f','','','0','1954-01-01','0.00','0.00','0','0','5','1359006482','1405994065','0000-00-00 00:00:00','127.0.0.1','4','0','0','196','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('5','','asdf@asd1f.com','yingying','fa56b61d25a1fd144da31a7909954b9b','','','0','1954-01-01','800.00','0.00','3000','9103','2','1361776277','1413853018','0000-00-00 00:00:00','127.0.0.1','78','3','0','4864','0','0','0','','','','','','','0','1000.00','','','','0','pc');");
E_D("replace into `ecs_users` values('6','','asdf@zsdfc.om','yingying23','702fdd5c32843c46fb90f29d472ee0d7','','','0','0000-00-00','0.00','0.00','0','0','0','1366446304','1366446304','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('7','','ecshop@qq.com','ecshopceshi','41471d8f21c307f69cef58438c1742a2','','','0','0000-00-00','0.00','0.00','0','0','0','1401933257','1401933257','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('8','','68ecshop@qq.com','echsop开发','ae005ceb7e9a217cced2f8aa354187c7','','','0','1954-01-01','0.00','0.00','0','0','4','1401947627','1406772485','0000-00-00 00:00:00','127.0.0.1','15','0','0','0','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('9','','asdfasdf@163.com','pkcjaioh','96e79218965eb72c92a549dd5a330112','','','0','0000-00-00','0.00','0.00','0','0','0','1405497961','1405497961','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('10','','446198qcszyg@68ecshop.com','admin2008','88ce36a5d93e74ab4b4f19805220a0a4','','','0','1954-01-01','0.00','0.00','3652','3652','32','1405505344','1418373852','0000-00-00 00:00:00','192.168.0.180','1143','0','0','6086','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('11','','yangsong@163.com','yvhmopja','9973e4f71ce54a3f52508efc7b08ea24','','','0','0000-00-00','0.00','0.00','0','0','9','1409536599','1409539277','0000-00-00 00:00:00','127.0.0.1','2','0','0','8229','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('12','','628837mboqaz@68ecshop.com','test123','00ef8df3e9409ee03f1573bb1ae32920','','','0','0000-00-00','0.00','0.00','200','200','5','1410742444','1413422946','0000-00-00 00:00:00','127.0.0.1','29','0','0','4304','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('13','','911326iierny@68ecshop.com','admin2014','2f938f055309045cecb8add234d96dd8','','','0','0000-00-00','9975319.31','0.00','1069531','70431','1','1411021755','1415954825','0000-00-00 00:00:00','192.168.0.154','1614','0','0','4713','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('14','','68334444@qq.cm','agcjlqmy','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','0000-00-00','0.00','0.00','0','0','0','1411021962','1411021962','0000-00-00 00:00:00','120.6.119.57','1','0','0','','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('15','','411159zsdsln@68ecshop.com','admin001','2f938f055309045cecb8add234d96dd8','','','0','1954-01-01','0.00','0.00','0','0','0','1411021964','1413795366','0000-00-00 00:00:00','192.168.0.154','2','0','0','0','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('16','','asdfg@qq.com','yptyrgul','25f9e794323b453885f5181f1b624d0b','','','0','1954-01-01','0.00','0.00','19032','19032','2','1411022029','1411089433','0000-00-00 00:00:00','120.6.119.57','111','0','0','0','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('17','','682766wuxziy@68ecshop.com','admin002','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','0000-00-00','0.00','0.00','0','0','0','1411022367','1411022367','0000-00-00 00:00:00','120.6.119.57','1','0','0','','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('18','','qwert@qq.com','bvbwknld','e4291b70ed1883165264b5feb79d37c5','','','0','0000-00-00','0.00','0.00','0','0','3','1411022536','1411089928','0000-00-00 00:00:00','120.6.119.57','107','0','0','5218','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('19','','445013lerxsn@68ecshop.com','admin003','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','0000-00-00','0.00','0.00','0','0','0','1411022621','1411022621','0000-00-00 00:00:00','120.6.119.57','1','0','0','','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('20','','zxcvv@qq.com','bvwftpng','e99a18c428cb38d5f260853678922e03','','','0','1954-01-01','0.00','0.00','0','0','4','1411022857','1411095643','0000-00-00 00:00:00','120.6.74.100','952','0','0','0','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('21','','277817eqxwot@68ecshop.com','qq68ecshop','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','0000-00-00','0.00','0.00','0','0','0','1411373776','1411373776','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','','0','pc');");
E_D("replace into `ecs_users` values('22','','woshi_wuhua@163.com','vnotraoe','ca94b74f358c6dc7bf43c6e63d0682fc','','','0','0000-00-00','0.00','0.00','0','0','0','1411700929','1411700929','0000-00-00 00:00:00','192.168.0.165','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('23','','test@123.com','ruqogpet','a6ee1a3fc9e0e169d7e886ed89cadaba','','','0','0000-00-00','0.00','0.00','0','0','0','1411897509','1411897651','0000-00-00 00:00:00','127.0.0.1','3','0','0','1516','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','mobile');");
E_D("replace into `ecs_users` values('24','','hehe@hehe.com','jgzvfqkg','e99a18c428cb38d5f260853678922e03','','','1','1990-01-01','0.00','0.00','0','0','6','1411952276','1411952277','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','mobile');");
E_D("replace into `ecs_users` values('25','','test@163.com','xbixxxtt','05a671c66aefea124cc08b76ea6d30bb','','','0','0000-00-00','0.00','0.00','0','0','8','1413424498','1413424498','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('26','','haha@haha.com','haha','a5a1512dcc38bf64155887e555b6fed7','','','0','0000-00-00','787.75','0.00','0','0','13','1413425567','1420528795','0000-00-00 00:00:00','127.0.0.1','155','0','0','8534','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('27','','906371075@qq.com','admin123','9967f1e078cedad4bef79917e7f59ba0','','','0','0000-00-00','0.00','0.00','0','0','10','1413768840','1415584017','0000-00-00 00:00:00','192.168.0.154','2','0','0','8461','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('28','','9063711075@qq.com','zhangzeren','0192023a7bbd73250516f069df18b500','','','0','0000-00-00','0.00','0.00','0','0','11','1413784504','1413784504','0000-00-00 00:00:00','192.168.0.154','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('29','','18798790987@163.com','mtzllhoy','96e79218965eb72c92a549dd5a330112','','','0','0000-00-00','0.00','0.00','0','0','0','1414468459','1414468460','0000-00-00 00:00:00','192.168.0.154','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('30','','wushiping05@21cn.com','fydvhixw','5e8c57b61478036ea7cd3b44824b2810','','','0','0000-00-00','0.00','0.00','0','0','0','1414558264','1414558264','0000-00-00 00:00:00','192.168.0.153','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('31','','o@68ecshop.com','wwgutmeg','9982b2a7fceaaee2c8444b5086aee008','','','0','0000-00-00','0.00','0.00','0','0','0','1415176794','1415176794','0000-00-00 00:00:00','192.168.0.154','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('32','','453562tywmys@68ecshop.com','ceshi','b9525a243d9d8619601ccb7afee1613f','','','0','0000-00-00','0.00','0.00','0','0','15','1415603333','1415603333','0000-00-00 00:00:00','192.168.0.154','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('33','','240007tzkugl@68ecshop.com','admin9','e10adc3949ba59abbe56e057f20f883e','','','0','1954-01-01','0.00','0.00','0','0','16','1415945743','1416884636','0000-00-00 00:00:00','192.168.0.150','2','0','0','0','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('34','','85152820@qq.com','iyrdplbl','db506d1f9938dfa6aced469e421fe7df','','','0','0000-00-00','0.00','0.00','300','300','17','1416969826','1416971680','0000-00-00 00:00:00','192.168.0.154','4','0','0','3593','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('35','','625399893@qq.com','apihrpjn','2f474a8eb52f079c893d3ea9dba3c036','','','0','1954-01-01','0.00','0.00','0','0','18','1416973358','1416973605','0000-00-00 00:00:00','192.168.0.154','2','0','0','0','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('36','','419922pbbohs@68ecshop.com','a625399893','2f474a8eb52f079c893d3ea9dba3c036','','','0','0000-00-00','0.00','0.00','0','0','0','1416975884','1416975884','0000-00-00 00:00:00','192.168.0.154','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('37','','489475zdqgju@68ecshop.com','bqmwluie','5a0ec87a6361ae5921fd7c66016384bc','','','0','0000-00-00','0.00','0.00','0','0','0','1416993574','1416993793','0000-00-00 00:00:00','127.0.0.1','2','0','0','2411','0','0','0','','','','','','13681561210','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('38','','673356edwwod@68ecshop.com','hihi','e99a18c428cb38d5f260853678922e03','','','0','0000-00-00','0.00','0.00','0','0','20','1417674979','1417674979','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('39','','971205mytvcn@68ecshop.com','yonghu1','2c3ea6f69a2daed70b53b8c3ea25694e','','','0','1960-01-01','0.00','0.00','11969','11969','23','1417758629','1418353539','0000-00-00 00:00:00','192.168.0.179','1806','0','0','1869','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('40','','565263dhuyep@68ecshop.com','xiaoan','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','0000-00-00','0.00','0.00','0','0','0','1417758809','1417758809','0000-00-00 00:00:00','192.168.0.149','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('41','','szyy@68ecshop.com','bykkcumt','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','0000-00-00','0.00','0.00','0','0','0','1417760355','1417760355','0000-00-00 00:00:00','192.168.0.170','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('42','','105716dliewe@68ecshop.com','jiangtianhao','957fc360f39fa3540341704f4cbb76c0','','','0','0000-00-00','0.00','0.00','8129118','8129118','42','1417771192','1418356646','0000-00-00 00:00:00','127.0.0.1','11','0','0','4981','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('43','','ecshopyy@qq.com','slnifylv','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','1954-01-01','0.00','0.00','0','0','0','1417771209','1417771864','0000-00-00 00:00:00','192.168.0.170','2','0','0','0','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('44','','610731mmtncl@68ecshop.com','ecshopyy','60129c7eee0e9af1c24b80aa08b6d21a','','','0','0000-00-00','0.00','0.00','12804','12804','40','1417772172','1418368004','0000-00-00 00:00:00','192.168.0.100','38','0','0','6290','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('45','','ecshopy@68ecshop.com','xdbjufbh','2d14f0a7ff531d44baa35a0f98ea9f39','','','0','0000-00-00','0.00','0.00','0','0','0','1418365601','1418365601','0000-00-00 00:00:00','192.168.0.100','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");
E_D("replace into `ecs_users` values('46','','757065fhlwvp@68ecshop.com','68ecshopyy','e10adc3949ba59abbe56e057f20f883e','','','0','1955-01-01','0.00','0.00','6926','6926','44','1418365640','1436060305','0000-00-00 00:00:00','127.0.0.1','8','0','0','0','0','0','0','','','','','','','0','0.00',NULL,NULL,'','0','pc');");

require("../../inc/footer.php");
?>